Overview

Dataset info

Number of variables8
Number of observations196203
Missing cells0 (0.0%)
Duplicate rows0 (0.0%)
Total size in memory12.0 MiB
Average record size in memory64.0 B

Variables types

Numeric5
Categorical1
Boolean0
Date1
URL0
Text (Unique)0
Rejected1
Unsupported0

Warnings

city has a high cardinality: 89 distinct values Warning
state has constant value "WestBengal" Rejected

Variables

city
Categorical

Distinct count89
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Calcutta
122381
Arambagh
 
1929
Gangarampur
 
1366
Other values (86)
70527
ValueCountFrequency (%) 
Calcutta 122381 62.4%
 
Arambagh 1929 1.0%
 
Gangarampur 1366 0.7%
 
IngrajBazar 1352 0.7%
 
Krishnanagar 1344 0.7%
 
Panihati 1341 0.7%
 
RampurHat 1328 0.7%
 
Naihati 1267 0.6%
 
Halisahar 1257 0.6%
 
Bankura 1252 0.6%
 
Other values (79) 61386 31.3%
 
Max length26
Mean length8.301376635
Min length5
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

device_id
Numeric

Distinct count7436
Unique (%)3.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean4.27965896e+16
Minimum-9.220061629e+18
Maximum9.215085116e+18
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum-9.220061629e+18
5-th percentile-8.273967625e+18
Q1-4.600581613e+18
Median8.280934626e+16
Q34.642411344e+18
95-th percentile8.298932734e+18
Maximum9.215085116e+18
Range1.843514675e+19
Interquartile range9.242992957e+18

Descriptive statistics

Standard deviation5.320733179e+18
Coef of variation124.3261024
Kurtosis-1.21568132
Mean4.27965896e+16
MAD4.628248174e+18
Skewness-0.01189279214
Sum8.396819269e+21
Variance2.831020157e+37
Memory size1.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-9.22006163e+18 -9.21951131e+18 -9.21729987e+18 -9.21549583e+18 -9.20608783e+18 ... 9.20079676e+18 9.20811890e+18 9.20942743e+18 9.21506135e+18 9.21508512e+18], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
4.620270825e+18 777 0.4%
 
-5.858653205e+18 561 0.3%
 
8.088848068e+17 355 0.2%
 
5.867303249e+18 352 0.2%
 
-4.811787453e+18 344 0.2%
 
2.690316833e+18 330 0.2%
 
1.429828157e+18 287 0.1%
 
5.903812345e+18 275 0.1%
 
-3.115936487e+18 269 0.1%
 
8.948594075e+18 267 0.1%
 
Other values (7426) 192386 98.1%
 

Minimum 5 values

ValueCountFrequency (%) 
-9.220061629e+18 52 < 0.1%
 
-9.218960997e+18 6 < 0.1%
 
-9.215638742e+18 72 < 0.1%
 
-9.215352914e+18 18 < 0.1%
 
-9.206882336e+18 12 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
9.215085116e+18 28 < 0.1%
 
9.215037578e+18 2 < 0.1%
 
9.212543527e+18 2 < 0.1%
 
9.210120344e+18 4 < 0.1%
 
9.208734509e+18 28 < 0.1%
 

df_index
Numeric

Distinct count196203
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean2981176.296
Minimum2829979
Maximum3252948
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2829979
5-th percentile2839789.1
Q12879029.5
Median2928080
Q33091612.5
95-th percentile3220811.9
Maximum3252948
Range422969
Interquartile range212583

Descriptive statistics

Standard deviation126440.2632
Coef of variation0.04241287689
Kurtosis-0.9404284929
Mean2981176.296
MAD112001.6947
Skewness0.6901576069
Sum5.849157328e+11
Variance1.598714016e+10
Memory size1.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[2829979. 2951414.5 3000961.5 3001211.5 3001509.5 ... 3248395.5 3248420.5 3249317. 3249403.5 3252948. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
2885631 1 < 0.1%
 
2911783 1 < 0.1%
 
2938416 1 < 0.1%
 
2895407 1 < 0.1%
 
2893358 1 < 0.1%
 
2899501 1 < 0.1%
 
2897452 1 < 0.1%
 
2887211 1 < 0.1%
 
2885162 1 < 0.1%
 
2891305 1 < 0.1%
 
Other values (196193) 196193 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
2829979 1 < 0.1%
 
2829980 1 < 0.1%
 
2829981 1 < 0.1%
 
2829982 1 < 0.1%
 
2829983 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3252948 1 < 0.1%
 
3252946 1 < 0.1%
 
3252941 1 < 0.1%
 
3252939 1 < 0.1%
 
3252936 1 < 0.1%
 

event_id
Numeric

Distinct count196203
Unique (%)100.0%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean1629573.076
Minimum20881
Maximum3252924
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum20881
5-th percentile176715.5
Q1815183.5
Median1628160
Q32440303
95-th percentile3091701.1
Maximum3252924
Range3232043
Interquartile range1625119.5

Descriptive statistics

Standard deviation935423.8022
Coef of variation0.5740299813
Kurtosis-1.209810123
Mean1629573.076
MAD810671.3228
Skewness0.01053273643
Sum3.197271262e+11
Variance8.750176898e+11
Memory size1.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 20881. 74788.5 120023.5 123322. 202454.5 ... 2603128.5 2606569. 2630935. 2637331.5 3252924. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
786431 1 < 0.1%
 
872546 1 < 0.1%
 
1850490 1 < 0.1%
 
2072936 1 < 0.1%
 
2962782 1 < 0.1%
 
610409 1 < 0.1%
 
713264 1 < 0.1%
 
713390 1 < 0.1%
 
610406 1 < 0.1%
 
1220811 1 < 0.1%
 
Other values (196193) 196193 > 99.9%
 

Minimum 5 values

ValueCountFrequency (%) 
20881 1 < 0.1%
 
20883 1 < 0.1%
 
21055 1 < 0.1%
 
21058 1 < 0.1%
 
21277 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
3252924 1 < 0.1%
 
3252921 1 < 0.1%
 
3252899 1 < 0.1%
 
3252879 1 < 0.1%
 
3252878 1 < 0.1%
 

latitude
Numeric

Distinct count7314
Unique (%)3.7%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean22.98882747
Minimum21.806773
Maximum27.147792
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum21.806773
5-th percentile22.582249
Q122.609044
Median22.644512
Q322.825356
95-th percentile25.476231
Maximum27.147792
Range5.341019
Interquartile range0.216312

Descriptive statistics

Standard deviation0.9172970793
Coef of variation0.03990186452
Kurtosis8.365922274
Mean22.98882747
MAD0.553409874
Skewness2.983823957
Sum4510476.916
Variance0.8414339317
Memory size1.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[21.806773 21.806847 21.8145075 21.8281695 21.8282865 ... 27.1295945 27.1392895 27.145219 27.147449 27.147792 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
22.95798 777 0.4%
 
25.484459 561 0.3%
 
22.806273 355 0.2%
 
26.75609 352 0.2%
 
22.750621 344 0.2%
 
22.756079 330 0.2%
 
23.70973 287 0.1%
 
22.530119 275 0.1%
 
23.020517 269 0.1%
 
23.75607 267 0.1%
 
Other values (7304) 192386 98.1%
 

Minimum 5 values

ValueCountFrequency (%) 
21.806773 178 0.1%
 
21.806921 2 < 0.1%
 
21.810245 4 < 0.1%
 
21.811075 3 < 0.1%
 
21.81794 27 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
27.147792 14 < 0.1%
 
27.147106 1 < 0.1%
 
27.143332 243 0.1%
 
27.135247 6 < 0.1%
 
27.132306 3 < 0.1%
 

longitude
Numeric

Distinct count7259
Unique (%)3.7%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean88.34604679
Minimum86.371717
Maximum89.622073
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum86.371717
5-th percentile87.425562
Q188.381672
Median88.412353
Q388.443469
95-th percentile88.579227
Maximum89.622073
Range3.250356
Interquartile range0.061797

Descriptive statistics

Standard deviation0.3440938498
Coef of variation0.003894841505
Kurtosis8.402974835
Mean88.34604679
MAD0.1812864749
Skewness-2.036429841
Sum17333759.42
Variance0.1184005775
Memory size1.5 MiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[86.371717 86.3730595 86.387368 86.392515 86.4031505 ... 89.5767465 89.5850595 89.613168 89.6170965 89.622073 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
87.81271 777 0.4%
 
88.619418 561 0.3%
 
88.459303 355 0.2%
 
88.442747 355 0.2%
 
89.067475 352 0.2%
 
87.794606 330 0.2%
 
88.3968 311 0.2%
 
87.125649 287 0.1%
 
88.183383 275 0.1%
 
88.526978 269 0.1%
 
Other values (7249) 192331 98.0%
 

Minimum 5 values

ValueCountFrequency (%) 
86.371717 20 < 0.1%
 
86.374402 7 < 0.1%
 
86.379668 1 < 0.1%
 
86.382335 1 < 0.1%
 
86.392401 127 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
89.622073 5 < 0.1%
 
89.61824 8 < 0.1%
 
89.615953 49 < 0.1%
 
89.610383 10 < 0.1%
 
89.605458 24 < 0.1%
 

state
Constant

This variable is constant and should be ignored for analysis

Constant valueWestBengal

timestamp
Date

Distinct count161928
Unique (%)82.5%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Minimum2016-04-30 23:52:42
Maximum2016-05-07 23:58:45
Mini histogram
Histogram
Histogram of 'timestamp' (bins=N)

Correlations

Missing values

Sample

First rows

citydevice_iddf_indexevent_idlatitudelongitudestatetimestamp
0Calcutta6,173,131,034,529,612,800.0282997974,778.022.788.4WestBengal2016-05-01 08:02:02
1Calcutta6,173,131,034,529,612,800.02829980527,238.022.788.4WestBengal2016-05-02 21:03:22
2Calcutta6,173,131,034,529,612,800.028299811,264,753.022.788.4WestBengal2016-05-06 21:36:26
3Calcutta6,173,131,034,529,612,800.028299822,252,310.022.788.4WestBengal2016-05-03 23:02:19
4Calcutta6,173,131,034,529,612,800.028299832,318,262.022.788.4WestBengal2016-05-03 09:11:20
5Calcutta6,173,131,034,529,612,800.028299842,702,195.022.788.4WestBengal2016-05-06 14:14:55
6Calcutta-5,235,317,150,879,700,992.0282998574,799.022.688.4WestBengal2016-05-01 08:04:22
7Calcutta-5,235,317,150,879,700,992.02829986125,577.022.688.4WestBengal2016-05-03 08:06:37
8Calcutta-5,235,317,150,879,700,992.02829987158,832.022.688.4WestBengal2016-05-02 20:04:02
9Calcutta-5,235,317,150,879,700,992.02829988314,703.022.688.4WestBengal2016-05-07 17:48:07

Last rows

citydevice_iddf_indexevent_idlatitudelongitudestatetimestamp
196193Midnapur-4,919,174,698,385,835,008.032529193,184,776.022.387.2WestBengal2016-05-01 21:30:13
196194Ulubaria-4,552,285,837,066,377,728.032529233,192,738.022.688.2WestBengal2016-05-04 09:23:07
196195Halisahar1,519,551,036,077,466,624.032529243,194,163.023.088.5WestBengal2016-05-02 10:05:51
196196Bhatpara-5,129,956,098,559,089,664.032529313,211,952.022.988.5WestBengal2016-05-01 21:35:47
196197Kharagpur7,270,157,325,938,748,416.032529353,225,021.022.487.4WestBengal2016-05-01 07:35:56
196198Ulubaria-8,840,776,028,151,301,120.032529363,226,367.022.588.2WestBengal2016-05-07 07:17:30
196199Chandannagar2,605,489,749,424,531,456.032529393,233,027.022.988.5WestBengal2016-05-07 11:04:27
196200Khardaha2,635,834,801,405,064,192.032529413,236,035.022.788.5WestBengal2016-05-06 13:51:35
196201Jangipur8,855,297,542,706,204,672.032529463,241,929.024.688.1WestBengal2016-05-05 17:05:08
196202Bally7,886,184,544,906,737,664.032529483,248,517.022.788.4WestBengal2016-05-04 21:35:09